Oracle 10G 数据库存储迁移手册

王巧雷 twt企业IT社区 2022-07-03

Oracle 10G 数据库存储迁移

作者：王巧雷

（手机横过来看代码更清晰）

文档说明

本文专门为项目中的Oracle部分编写，涉及Oracle存储迁移及Oracle存储方式的变更（fs-asm）

基本环境

os版本：centos5.5
db版本：oracle10.2.0.1

export PS1="`/bin/hostname -s`-> "

export EDITOR=vi

export ORACLE_SID=orcl

export ORACLE_BASE=/database

export ORACLE_HOME=$ORACLE_BASE/oracle

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH=$ORACLE_HOME/bin:$PATH

umask 022

测试信息

create tablespace wql datafile '/database/oradata/orcl/wql.dbf' size 100M;

create user wql identified by oracle default tablespace wql;

grant connect,resource to wql;

conn wql/oracle；

create table t(id int,name varchar(15));

insert into t values(1,'wql');

select * from t;

ID NAME

---------- ---------------

1 wql

替换规划

原有的：
数据文件：/dev/sda /database/oradata
归档：/dev/sda /arch

新存储：
/dev/sdb1、/dev/sdc1、/dev/sdd1对应asm的+DG1
存放数据文件

/dev/sde1 对应asm的+DG2 存放归档日志
/dev/sdf1 对应asm的+DG3 闪回区域

实施过程

安装配置asmlib

安装

[root@db2awse ~]# rpm -qa|grep oracle

oracleasm-2.6.18-398.el5-2.0.5-1.el5

oracleasmlib-2.0.4-1.el5

oracleasm-support-2.1.8-1.el5

配置

[root@db2awse ~]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

Default user to own the driver interface []: oracle

Default group to own the driver interface []: dba

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLib disks: [ OK ]

使用fdisk /dev/sdx配置磁盘，过程略

创建asmdisk

[root@db2awse ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1

Marking disk "VOL1" as an ASM disk: [ OK ]

[root@db2awse ~]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1

Marking disk "VOL2" as an ASM disk: [ OK ]

[root@db2awse ~]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1

Marking disk "VOL3" as an ASM disk: [ OK ]

[root@db2awse ~]# /etc/init.d/oracleasm createdisk VOL4 /dev/sde1

Marking disk "VOL4" as an ASM disk: [ OK ]

[root@db2awse ~]# /etc/init.d/oracleasm createdisk VOL5 /dev/sdf1

Marking disk "VOL5" as an ASM disk: [ OK ]

[root@db2awse ~]# /etc/init.d/oracleasm listdisks

VOL1

VOL2

VOL3

VOL4

VOL5

配置asm实例

启动css，以root执行

[root@db2awse ~]# whoami

root

[root@db2awse ~]# /database/oracle/bin/localconfig add

/etc/oracle does not exist. Creating it now.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Configuration for local CSS has been initialized

Adding to inittab

Startup will be queued to init within 90 seconds.

Checking the status of new Oracle init process...

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

db2awse

CSS is active on all nodes.

Oracle CSS service is installed and running under init(1M)

创建ASM实例的pfile文件，内容如下：

$ cat $ORACLE_HOME/dbs/init+ASM.ora

instance_type=asm

large_pool_size=12M

remote_login_passwordfile=exclusive

asm_diskstring='/dev/oracleasm/disks/VOL*'

background_dump_dest=/database/admin/+ASM/bdump

core_dump_dest=/database/admin/+ASM/cdump

user_dump_dest=/database/admin/+ASM/udump

创建ASM实例的password文件

db2awse-> orapwd file=orapw+ASM entries=5 password=oracle

启动asm实例，还没创建diskgroup，报错忽略

db2awse-> export ORACLE_SID=+ASM

db2awse-> sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 13:40:48 2016

Connected to an idle instance.

SQL> startup

ASM instance started

Total System Global Area 130023424 bytes

Fixed Size 2019032 bytes

Variable Size 102838568 bytes

ASM Cache 25165824 bytes

ORA-15110: no diskgroups mounted

创建diskgroup

SQL> create diskgroup dg1 external redundancy disk '/dev/oracleasm/disks/VOL1','/dev/oracleasm/disks/VOL2','/dev/oracleasm/disks/VOL3';

Diskgroup created.

SQL> create diskgroup dg2 external redundancy disk '/dev/oracleasm/disks/VOL4';

Diskgroup created.

SQL> create diskgroup recover external redundancy disk '/dev/oracleasm/disks/VOL5';

Diskgroup created.

创建数据库备份

db2awse-> rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Dec 5 13:51:54 2016

connected to target database: ORCL (DBID=1457578197)

RMAN> run {

2> backup as copy database format '+DG1';

3> }

Starting backup at 05-DEC-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=158 devtype=DISK